<?php
//       PHPcongrats - Holiday and Birthday Mailer
//     
//    Copyright (C) 2011  Matthias Nass
//
//    This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.
//
//    This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
//
//    You should have received a copy of the GNU General Public License along with this program; if not, see <http://www.gnu.org/licenses/>.
session_start();

if ($_SESSION['loggedin'] == true){

     $id = (int) $_POST['id'];
     
     if (($_POST['name']=='')){
     		$_SESSION['message'] = "Name ist leer!";
     		$location_to_jump = "Location: http:./holidaycha.php";
     		header( $location_to_jump );         
     }else{
             if ($_POST['revising'] == 'on'){
                  $revising=1;
             }else{
                  $revising=0;
             }
             include "./DBconnect.php";
             $query = "UPDATE holidays SET 
             name='".mysql_real_escape_string($_POST['name'])."',
             date='".(int) $_POST['year']."-".(int) $_POST['month']."-".(int) $_POST['day']."',
             revising='".$revising."',
             region='".mysql_real_escape_string($_POST['region'])."',
             country='".mysql_real_escape_string($_POST['country'])."',
  			 changed=CURRENT_TIMESTAMP WHERE id=".$id.";";   
             $result = mysql_db_query($database, $query, $link);
             mysql_close($link);
            if($result == false){
     		$_SESSION['message'] = "Datenbankfehler";
     		$location_to_jump = "Location: http:./holidaycha.php?id=".$id."";
     		header( $location_to_jump );          
             }else {
            $_SESSION['message'] = "Feiertag ge&auml;ndert";
     		$location_to_jump = "Location: http:./holidays.php";
     		header( $location_to_jump );                       
             }    			
     }
} else{
	$_SESSION['last_location'] = "./holidaycha.php";
	header( 'Location: http:./login.php' );
}
?>